Dataset statistics
| Number of variables | 27 |
|---|---|
| Number of observations | 1000 |
| Missing cells | 5364 |
| Missing cells (%) | 19.9% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 211.1 KiB |
| Average record size in memory | 216.1 B |
Variable types
| CAT | 15 |
|---|---|
| NUM | 11 |
| UNSUPPORTED | 1 |
Date Reported has a high cardinality: 864 distinct values | High cardinality |
Date Occurred has a high cardinality: 858 distinct values | High cardinality |
Crime Code Description has a high cardinality: 70 distinct values | High cardinality |
MO Codes has a high cardinality: 593 distinct values | High cardinality |
Premise Description has a high cardinality: 77 distinct values | High cardinality |
Address has a high cardinality: 935 distinct values | High cardinality |
Cross Street has a high cardinality: 154 distinct values | High cardinality |
Location has a high cardinality: 954 distinct values | High cardinality |
DR Number is highly correlated with df_index and 1 other fields | High correlation |
df_index is highly correlated with DR Number and 1 other fields | High correlation |
Reporting District is highly correlated with Area ID and 1 other fields | High correlation |
Area ID is highly correlated with Reporting District and 1 other fields | High correlation |
Crime Code 1 is highly correlated with Crime Code and 1 other fields | High correlation |
Crime Code is highly correlated with Crime Code 1 and 1 other fields | High correlation |
Crime Code 3 is highly correlated with df_index and 9 other fields | High correlation |
Time Occurred is highly correlated with Crime Code 3 | High correlation |
Victim Age is highly correlated with Crime Code 3 | High correlation |
Premise Code is highly correlated with Crime Code 3 | High correlation |
Crime Code 2 is highly correlated with Crime Code 3 | High correlation |
Status Description is highly correlated with Status Code | High correlation |
Status Code is highly correlated with Status Description | High correlation |
MO Codes has 110 (11.0%) missing values | Missing |
Victim Sex has 94 (9.4%) missing values | Missing |
Victim Descent has 94 (9.4%) missing values | Missing |
Weapon Used Code has 659 (65.9%) missing values | Missing |
Weapon Description has 659 (65.9%) missing values | Missing |
Crime Code 2 has 931 (93.1%) missing values | Missing |
Crime Code 3 has 998 (99.8%) missing values | Missing |
Crime Code 4 has 1000 (100.0%) missing values | Missing |
Cross Street has 817 (81.7%) missing values | Missing |
Date Reported is uniformly distributed | Uniform |
Date Occurred is uniformly distributed | Uniform |
Crime Code 3 is uniformly distributed | Uniform |
Address is uniformly distributed | Uniform |
Cross Street is uniformly distributed | Uniform |
Location is uniformly distributed | Uniform |
df_index has unique values | Unique |
DR Number has unique values | Unique |
Crime Code 4 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Victim Age has 169 (16.9%) zeros | Zeros |
Reproduction
| Analysis started | 2021-08-09 13:56:57.839862 |
|---|---|
| Analysis finished | 2021-08-09 13:57:45.130500 |
| Duration | 47.29 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
| Distinct | 1000 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 987928.7 |
|---|---|
| Minimum | 548 |
| Maximum | 1993248 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.8 KiB |
Quantile statistics
| Minimum | 548 |
|---|---|
| 5-th percentile | 115864 |
| Q1 | 478503.5 |
| median | 997321 |
| Q3 | 1475642.5 |
| 95-th percentile | 1897505.3 |
| Maximum | 1993248 |
| Range | 1992700 |
| Interquartile range (IQR) | 997139 |
Descriptive statistics
| Standard deviation | 572949.2855 |
|---|---|
| Coefficient of variation (CV) | 0.5799500364 |
| Kurtosis | -1.200724843 |
| Mean | 987928.7 |
| Median Absolute Deviation (MAD) | 498564.5 |
| Skewness | 0.03807213977 |
| Sum | 987928700 |
| Variance | 3.282708838e+11 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 1871871 | 1 | 0.1% | |
| 1477282 | 1 | 0.1% | |
| 1448636 | 1 | 0.1% | |
| 1835704 | 1 | 0.1% | |
| 1852650 | 1 | 0.1% | |
| 1045173 | 1 | 0.1% | |
| 1378996 | 1 | 0.1% | |
| 1802931 | 1 | 0.1% | |
| 874471 | 1 | 0.1% | |
| 1395371 | 1 | 0.1% | |
| Other values (990) | 990 | 99.0% |
| Value | Count | Frequency (%) | |
| 548 | 1 | 0.1% | |
| 1410 | 1 | 0.1% | |
| 1670 | 1 | 0.1% | |
| 2780 | 1 | 0.1% | |
| 9316 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 1993248 | 1 | 0.1% | |
| 1992417 | 1 | 0.1% | |
| 1991349 | 1 | 0.1% | |
| 1983140 | 1 | 0.1% | |
| 1974389 | 1 | 0.1% |
| Distinct | 1000 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 144863519.5 |
|---|---|
| Minimum | 100118167 |
| Maximum | 192111869 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.8 KiB |
Quantile statistics
| Minimum | 100118167 |
|---|---|
| 5-th percentile | 101096442 |
| Q1 | 121015744.2 |
| median | 150209692 |
| Q3 | 170514365 |
| 95-th percentile | 190209416.4 |
| Maximum | 192111869 |
| Range | 91993702 |
| Interquartile range (IQR) | 49498620.75 |
Descriptive statistics
| Standard deviation | 27553414.89 |
|---|---|
| Coefficient of variation (CV) | 0.1902025781 |
| Kurtosis | -1.196783376 |
| Mean | 144863519.5 |
| Median Absolute Deviation (MAD) | 21299527.5 |
| Skewness | -0.04636664928 |
| Sum | 1.448635195e+11 |
| Variance | 7.591906719e+14 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 172111867 | 1 | 0.1% | |
| 132018867 | 1 | 0.1% | |
| 120400593 | 1 | 0.1% | |
| 140509901 | 1 | 0.1% | |
| 190710476 | 1 | 0.1% | |
| 191507147 | 1 | 0.1% | |
| 120200647 | 1 | 0.1% | |
| 181412552 | 1 | 0.1% | |
| 110220169 | 1 | 0.1% | |
| 111705278 | 1 | 0.1% | |
| Other values (990) | 990 | 99.0% |
| Value | Count | Frequency (%) | |
| 100118167 | 1 | 0.1% | |
| 100206791 | 1 | 0.1% | |
| 100208885 | 1 | 0.1% | |
| 100217227 | 1 | 0.1% | |
| 100218154 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 192111869 | 1 | 0.1% | |
| 192110416 | 1 | 0.1% | |
| 192108522 | 1 | 0.1% | |
| 191910337 | 1 | 0.1% | |
| 191804633 | 1 | 0.1% |
| Distinct | 864 |
|---|---|
| Distinct (%) | 86.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.8 KiB |
| 2010-08-09T00:00:00 | 4 |
|---|---|
| 2015-11-15T00:00:00 | 3 |
| 2013-01-12T00:00:00 | 3 |
| 2010-11-09T00:00:00 | 3 |
| 2013-03-20T00:00:00 | 3 |
| Other values (859) |
| Value | Count | Frequency (%) | |
| 2010-08-09T00:00:00 | 4 | 0.4% | |
| 2015-11-15T00:00:00 | 3 | 0.3% | |
| 2013-01-12T00:00:00 | 3 | 0.3% | |
| 2010-11-09T00:00:00 | 3 | 0.3% | |
| 2013-03-20T00:00:00 | 3 | 0.3% | |
| 2018-02-05T00:00:00 | 3 | 0.3% | |
| 2010-10-15T00:00:00 | 3 | 0.3% | |
| 2011-06-04T00:00:00 | 3 | 0.3% | |
| 2012-07-03T00:00:00 | 3 | 0.3% | |
| 2016-07-14T00:00:00 | 3 | 0.3% | |
| Other values (854) | 969 | 96.9% |
Frequencies of value counts
Unique
| Unique | 740 ? |
|---|---|
| Unique (%) | 74.0% |
Histogram of lengths of the category
Length
| Max length | 22 |
|---|---|
| Median length | 19 |
| Mean length | 19.156 |
| Min length | 19 |
| Distinct | 858 |
|---|---|
| Distinct (%) | 85.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.8 KiB |
| 2011-01-01T00:00:00 | 4 |
|---|---|
| 2010-12-03T00:00:00 | 4 |
| 2011-01-26T00:00:00 | 3 |
| 2011-11-08T00:00:00 | 3 |
| 2010-12-01T00:00:00 | 3 |
| Other values (853) |
| Value | Count | Frequency (%) | |
| 2011-01-01T00:00:00 | 4 | 0.4% | |
| 2010-12-03T00:00:00 | 4 | 0.4% | |
| 2011-01-26T00:00:00 | 3 | 0.3% | |
| 2011-11-08T00:00:00 | 3 | 0.3% | |
| 2010-12-01T00:00:00 | 3 | 0.3% | |
| 2013-01-12T00:00:00 | 3 | 0.3% | |
| 2017-03-15T00:00:00 | 3 | 0.3% | |
| 2010-11-14T00:00:00 | 3 | 0.3% | |
| 2015-06-14T00:00:00 | 3 | 0.3% | |
| 2015-11-20T00:00:00 | 3 | 0.3% | |
| Other values (848) | 968 | 96.8% |
Frequencies of value counts
Unique
| Unique | 728 ? |
|---|---|
| Unique (%) | 72.8% |
Histogram of lengths of the category
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
| Distinct | 227 |
|---|---|
| Distinct (%) | 22.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1346.928 |
|---|---|
| Minimum | 1 |
| Maximum | 2359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 100 |
| Q1 | 920 |
| median | 1400 |
| Q3 | 1900 |
| 95-th percentile | 2300 |
| Maximum | 2359 |
| Range | 2358 |
| Interquartile range (IQR) | 980 |
Descriptive statistics
| Standard deviation | 666.2990299 |
|---|---|
| Coefficient of variation (CV) | 0.4946805099 |
| Kurtosis | -0.7790123195 |
| Mean | 1346.928 |
| Median Absolute Deviation (MAD) | 500 |
| Skewness | -0.4208786818 |
| Sum | 1346928 |
| Variance | 443954.3972 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 1200 | 52 | 5.2% | |
| 2200 | 34 | 3.4% | |
| 1900 | 32 | 3.2% | |
| 1000 | 26 | 2.6% | |
| 1800 | 25 | 2.5% | |
| 1500 | 24 | 2.4% | |
| 2300 | 23 | 2.3% | |
| 1 | 22 | 2.2% | |
| 1700 | 22 | 2.2% | |
| 2100 | 21 | 2.1% | |
| Other values (217) | 719 | 71.9% |
| Value | Count | Frequency (%) | |
| 1 | 22 | 2.2% | |
| 5 | 6 | 0.6% | |
| 10 | 4 | 0.4% | |
| 15 | 2 | 0.2% | |
| 20 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 2359 | 1 | 0.1% | |
| 2355 | 2 | 0.2% | |
| 2350 | 2 | 0.2% | |
| 2345 | 4 | 0.4% | |
| 2340 | 3 | 0.3% |
| Distinct | 21 |
|---|---|
| Distinct (%) | 2.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.003 |
|---|---|
| Minimum | 1 |
| Maximum | 21 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 6 |
| median | 11.5 |
| Q3 | 16 |
| 95-th percentile | 20 |
| Maximum | 21 |
| Range | 20 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 6.024224621 |
|---|---|
| Coefficient of variation (CV) | 0.5475074635 |
| Kurtosis | -1.218719532 |
| Mean | 11.003 |
| Median Absolute Deviation (MAD) | 5.5 |
| Skewness | -0.02336680459 |
| Sum | 11003 |
| Variance | 36.29128228 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=21)
| Value | Count | Frequency (%) | |
| 3 | 69 | 6.9% | |
| 12 | 68 | 6.8% | |
| 2 | 59 | 5.9% | |
| 13 | 57 | 5.7% | |
| 17 | 57 | 5.7% | |
| 20 | 52 | 5.2% | |
| 15 | 51 | 5.1% | |
| 14 | 48 | 4.8% | |
| 19 | 47 | 4.7% | |
| 8 | 46 | 4.6% | |
| Other values (11) | 446 | 44.6% |
| Value | Count | Frequency (%) | |
| 1 | 32 | 3.2% | |
| 2 | 59 | 5.9% | |
| 3 | 69 | 6.9% | |
| 4 | 40 | 4.0% | |
| 5 | 46 | 4.6% |
| Value | Count | Frequency (%) | |
| 21 | 40 | 4.0% | |
| 20 | 52 | 5.2% | |
| 19 | 47 | 4.7% | |
| 18 | 44 | 4.4% | |
| 17 | 57 | 5.7% |
Area Name
Categorical
| Distinct | 21 |
|---|---|
| Distinct (%) | 2.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.8 KiB |
| Southwest | 69 |
|---|---|
| 77th Street | 68 |
| Rampart | 59 |
| Newton | 57 |
| Devonshire | 57 |
| Other values (16) |
| Value | Count | Frequency (%) | |
| Southwest | 69 | 6.9% | |
| 77th Street | 68 | 6.8% | |
| Rampart | 59 | 5.9% | |
| Newton | 57 | 5.7% | |
| Devonshire | 57 | 5.7% | |
| Olympic | 52 | 5.2% | |
| N Hollywood | 51 | 5.1% | |
| Pacific | 48 | 4.8% | |
| Mission | 47 | 4.7% | |
| West LA | 46 | 4.6% | |
| Other values (11) | 446 | 44.6% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 11 |
|---|---|
| Median length | 8 |
| Mean length | 8.336 |
| Min length | 6 |
| Distinct | 601 |
|---|---|
| Distinct (%) | 60.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1147.689 |
|---|---|
| Minimum | 119 |
| Maximum | 2187 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.8 KiB |
Quantile statistics
| Minimum | 119 |
|---|---|
| 5-th percentile | 235 |
| Q1 | 628 |
| median | 1196 |
| Q3 | 1681.75 |
| 95-th percentile | 2071 |
| Maximum | 2187 |
| Range | 2068 |
| Interquartile range (IQR) | 1053.75 |
Descriptive statistics
| Standard deviation | 602.794183 |
|---|---|
| Coefficient of variation (CV) | 0.5252243274 |
| Kurtosis | -1.221347045 |
| Mean | 1147.689 |
| Median Absolute Deviation (MAD) | 539 |
| Skewness | -0.01626561609 |
| Sum | 1147689 |
| Variance | 363360.8271 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 363 | 8 | 0.8% | |
| 1684 | 8 | 0.8% | |
| 256 | 6 | 0.6% | |
| 1764 | 6 | 0.6% | |
| 636 | 6 | 0.6% | |
| 1267 | 6 | 0.6% | |
| 235 | 5 | 0.5% | |
| 358 | 5 | 0.5% | |
| 2029 | 5 | 0.5% | |
| 2156 | 5 | 0.5% | |
| Other values (591) | 940 | 94.0% |
| Value | Count | Frequency (%) | |
| 119 | 2 | 0.2% | |
| 124 | 1 | 0.1% | |
| 127 | 1 | 0.1% | |
| 132 | 1 | 0.1% | |
| 135 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 2187 | 1 | 0.1% | |
| 2183 | 2 | 0.2% | |
| 2177 | 3 | 0.3% | |
| 2175 | 1 | 0.1% | |
| 2158 | 1 | 0.1% |
| Distinct | 70 |
|---|---|
| Distinct (%) | 7.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 508.288 |
|---|---|
| Minimum | 121 |
| Maximum | 956 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.8 KiB |
Quantile statistics
| Minimum | 121 |
|---|---|
| 5-th percentile | 230 |
| Q1 | 330 |
| median | 442 |
| Q3 | 626 |
| 95-th percentile | 928 |
| Maximum | 956 |
| Range | 835 |
| Interquartile range (IQR) | 296 |
Descriptive statistics
| Standard deviation | 207.0217696 |
|---|---|
| Coefficient of variation (CV) | 0.4072922626 |
| Kurtosis | -0.7412935396 |
| Mean | 508.288 |
| Median Absolute Deviation (MAD) | 132 |
| Skewness | 0.4900477984 |
| Sum | 508288 |
| Variance | 42858.01307 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 624 | 90 | 9.0% | |
| 440 | 87 | 8.7% | |
| 330 | 82 | 8.2% | |
| 510 | 81 | 8.1% | |
| 310 | 76 | 7.6% | |
| 626 | 62 | 6.2% | |
| 354 | 51 | 5.1% | |
| 740 | 47 | 4.7% | |
| 745 | 41 | 4.1% | |
| 230 | 39 | 3.9% | |
| Other values (60) | 344 | 34.4% |
| Value | Count | Frequency (%) | |
| 121 | 4 | 0.4% | |
| 122 | 1 | 0.1% | |
| 210 | 38 | 3.8% | |
| 220 | 3 | 0.3% | |
| 230 | 39 | 3.9% |
| Value | Count | Frequency (%) | |
| 956 | 7 | 0.7% | |
| 949 | 1 | 0.1% | |
| 946 | 10 | 1.0% | |
| 940 | 1 | 0.1% | |
| 933 | 1 | 0.1% |
| Distinct | 70 |
|---|---|
| Distinct (%) | 7.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.8 KiB |
| BATTERY - SIMPLE ASSAULT | |
|---|---|
| THEFT PLAIN - PETTY ($950 & UNDER) | |
| BURGLARY FROM VEHICLE | |
| VEHICLE - STOLEN | |
| BURGLARY | |
| Other values (65) |
| Value | Count | Frequency (%) | |
| BATTERY - SIMPLE ASSAULT | 90 | 9.0% | |
| THEFT PLAIN - PETTY ($950 & UNDER) | 87 | 8.7% | |
| BURGLARY FROM VEHICLE | 82 | 8.2% | |
| VEHICLE - STOLEN | 81 | 8.1% | |
| BURGLARY | 76 | 7.6% | |
| INTIMATE PARTNER - SIMPLE ASSAULT | 62 | 6.2% | |
| THEFT OF IDENTITY | 51 | 5.1% | |
| VANDALISM - FELONY ($400 & OVER, ALL CHURCH VANDALISMS) | 47 | 4.7% | |
| VANDALISM - MISDEAMEANOR ($399 OR UNDER) | 41 | 4.1% | |
| ASSAULT WITH DEADLY WEAPON, AGGRAVATED ASSAULT | 39 | 3.9% | |
| Other values (60) | 344 | 34.4% |
Frequencies of value counts
Unique
| Unique | 22 ? |
|---|---|
| Unique (%) | 2.2% |
Histogram of lengths of the category
Length
| Max length | 56 |
|---|---|
| Median length | 24 |
| Mean length | 28.541 |
| Min length | 5 |
| Distinct | 593 |
|---|---|
| Distinct (%) | 66.6% |
| Missing | 110 |
| Missing (%) | 11.0% |
| Memory size | 7.8 KiB |
| 0344 | |
|---|---|
| 0329 | 26 |
| 0416 | 20 |
| 1501 | 16 |
| 0329 1300 | 12 |
| Other values (588) |
| Value | Count | Frequency (%) | |
| 0344 | 110 | 11.0% | |
| 0329 | 26 | 2.6% | |
| 0416 | 20 | 2.0% | |
| 1501 | 16 | 1.6% | |
| 0329 1300 | 12 | 1.2% | |
| 0325 | 11 | 1.1% | |
| 0344 1609 | 9 | 0.9% | |
| 0329 1307 | 8 | 0.8% | |
| 0377 | 7 | 0.7% | |
| 0416 2000 | 6 | 0.6% | |
| Other values (583) | 665 | 66.5% | |
| (Missing) | 110 | 11.0% |
Frequencies of value counts
Unique
| Unique | 532 ? |
|---|---|
| Unique (%) | 59.8% |
Histogram of lengths of the category
Length
| Max length | 49 |
|---|---|
| Median length | 9 |
| Mean length | 12.02 |
| Min length | 3 |
| Distinct | 79 |
|---|---|
| Distinct (%) | 7.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 31.758 |
|---|---|
| Minimum | -1 |
| Maximum | 86 |
| Zeros | 169 |
| Zeros (%) | 16.9% |
| Memory size | 7.8 KiB |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 20 |
| median | 31 |
| Q3 | 46.25 |
| 95-th percentile | 65 |
| Maximum | 86 |
| Range | 87 |
| Interquartile range (IQR) | 26.25 |
Descriptive statistics
| Standard deviation | 20.26435491 |
|---|---|
| Coefficient of variation (CV) | 0.6380866211 |
| Kurtosis | -0.631282624 |
| Mean | 31.758 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | 0.03777424644 |
| Sum | 31758 |
| Variance | 410.6440801 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 169 | 16.9% | |
| 23 | 27 | 2.7% | |
| 30 | 27 | 2.7% | |
| 32 | 25 | 2.5% | |
| 31 | 24 | 2.4% | |
| 21 | 23 | 2.3% | |
| 25 | 23 | 2.3% | |
| 27 | 22 | 2.2% | |
| 28 | 22 | 2.2% | |
| 33 | 21 | 2.1% | |
| Other values (69) | 617 | 61.7% |
| Value | Count | Frequency (%) | |
| -1 | 1 | 0.1% | |
| 0 | 169 | 16.9% | |
| 3 | 1 | 0.1% | |
| 6 | 3 | 0.3% | |
| 8 | 3 | 0.3% |
| Value | Count | Frequency (%) | |
| 86 | 1 | 0.1% | |
| 85 | 2 | 0.2% | |
| 83 | 1 | 0.1% | |
| 81 | 1 | 0.1% | |
| 80 | 1 | 0.1% |
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 94 |
| Missing (%) | 9.4% |
| Memory size | 7.8 KiB |
| M | |
|---|---|
| F | |
| X | 28 |
| Value | Count | Frequency (%) | |
| M | 454 | 45.4% | |
| F | 424 | 42.4% | |
| X | 28 | 2.8% | |
| (Missing) | 94 | 9.4% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 3 |
|---|---|
| Median length | 1 |
| Mean length | 1.188 |
| Min length | 1 |
| Distinct | 12 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 94 |
| Missing (%) | 9.4% |
| Memory size | 7.8 KiB |
| H | |
|---|---|
| W | |
| B | |
| O | |
| X | |
| Other values (7) | 27 |
| Value | Count | Frequency (%) | |
| H | 342 | 34.2% | |
| W | 231 | 23.1% | |
| B | 168 | 16.8% | |
| O | 98 | 9.8% | |
| X | 40 | 4.0% | |
| A | 18 | 1.8% | |
| K | 4 | 0.4% | |
| I | 1 | 0.1% | |
| U | 1 | 0.1% | |
| C | 1 | 0.1% | |
| Other values (2) | 2 | 0.2% | |
| (Missing) | 94 | 9.4% |
Frequencies of value counts
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | 0.6% |
Histogram of lengths of the category
Length
| Max length | 3 |
|---|---|
| Median length | 1 |
| Mean length | 1.188 |
| Min length | 1 |
| Distinct | 77 |
|---|---|
| Distinct (%) | 7.7% |
| Missing | 1 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 324.019019 |
|---|---|
| Minimum | 101 |
| Maximum | 964 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.8 KiB |
Quantile statistics
| Minimum | 101 |
|---|---|
| 5-th percentile | 101 |
| Q1 | 102 |
| median | 222 |
| Q3 | 501 |
| 95-th percentile | 708 |
| Maximum | 964 |
| Range | 863 |
| Interquartile range (IQR) | 399 |
Descriptive statistics
| Standard deviation | 217.5129477 |
|---|---|
| Coefficient of variation (CV) | 0.6712968527 |
| Kurtosis | -1.257899182 |
| Mean | 324.019019 |
| Median Absolute Deviation (MAD) | 121 |
| Skewness | 0.3356349188 |
| Sum | 323695 |
| Variance | 47311.8824 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 101 | 223 | 22.3% | |
| 501 | 202 | 20.2% | |
| 502 | 134 | 13.4% | |
| 108 | 62 | 6.2% | |
| 102 | 52 | 5.2% | |
| 203 | 48 | 4.8% | |
| 122 | 41 | 4.1% | |
| 707 | 22 | 2.2% | |
| 210 | 21 | 2.1% | |
| 404 | 15 | 1.5% | |
| Other values (67) | 179 | 17.9% |
| Value | Count | Frequency (%) | |
| 101 | 223 | 22.3% | |
| 102 | 52 | 5.2% | |
| 103 | 3 | 0.3% | |
| 104 | 13 | 1.3% | |
| 108 | 62 | 6.2% |
| Value | Count | Frequency (%) | |
| 964 | 1 | 0.1% | |
| 951 | 1 | 0.1% | |
| 912 | 1 | 0.1% | |
| 904 | 1 | 0.1% | |
| 834 | 1 | 0.1% |
| Distinct | 77 |
|---|---|
| Distinct (%) | 7.7% |
| Missing | 1 |
| Missing (%) | 0.1% |
| Memory size | 7.8 KiB |
| STREET | |
|---|---|
| SINGLE FAMILY DWELLING | |
| MULTI-UNIT DWELLING (APARTMENT, DUPLEX, ETC) | |
| PARKING LOT | |
| SIDEWALK | |
| Other values (72) |
| Value | Count | Frequency (%) | |
| STREET | 223 | 22.3% | |
| SINGLE FAMILY DWELLING | 202 | 20.2% | |
| MULTI-UNIT DWELLING (APARTMENT, DUPLEX, ETC) | 134 | 13.4% | |
| PARKING LOT | 62 | 6.2% | |
| SIDEWALK | 52 | 5.2% | |
| OTHER BUSINESS | 48 | 4.8% | |
| VEHICLE, PASSENGER/TRUCK | 41 | 4.1% | |
| GARAGE/CARPORT | 22 | 2.2% | |
| RESTAURANT/FAST FOOD | 21 | 2.1% | |
| DEPARTMENT STORE | 15 | 1.5% | |
| Other values (67) | 179 | 17.9% |
Frequencies of value counts
Unique
| Unique | 34 ? |
|---|---|
| Unique (%) | 3.4% |
Histogram of lengths of the category
Length
| Max length | 57 |
|---|---|
| Median length | 14 |
| Mean length | 18.303 |
| Min length | 3 |
| Distinct | 27 |
|---|---|
| Distinct (%) | 7.9% |
| Missing | 659 |
| Missing (%) | 65.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 375.3049853 |
|---|---|
| Minimum | 101 |
| Maximum | 515 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.8 KiB |
Quantile statistics
| Minimum | 101 |
|---|---|
| 5-th percentile | 104 |
| Q1 | 400 |
| median | 400 |
| Q3 | 400 |
| 95-th percentile | 511 |
| Maximum | 515 |
| Range | 414 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 112.1436091 |
|---|---|
| Coefficient of variation (CV) | 0.2988066066 |
| Kurtosis | 0.8148100971 |
| Mean | 375.3049853 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -1.212843017 |
| Sum | 127979 |
| Variance | 12576.18906 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=27)
| Value | Count | Frequency (%) | |
| 400 | 201 | 20.1% | |
| 500 | 36 | 3.6% | |
| 511 | 27 | 2.7% | |
| 102 | 15 | 1.5% | |
| 200 | 13 | 1.3% | |
| 109 | 7 | 0.7% | |
| 207 | 6 | 0.6% | |
| 308 | 4 | 0.4% | |
| 307 | 4 | 0.4% | |
| 302 | 4 | 0.4% | |
| Other values (17) | 24 | 2.4% | |
| (Missing) | 659 | 65.9% |
| Value | Count | Frequency (%) | |
| 101 | 2 | 0.2% | |
| 102 | 15 | 1.5% | |
| 104 | 2 | 0.2% | |
| 106 | 3 | 0.3% | |
| 109 | 7 | 0.7% |
| Value | Count | Frequency (%) | |
| 515 | 1 | 0.1% | |
| 513 | 1 | 0.1% | |
| 512 | 1 | 0.1% | |
| 511 | 27 | 2.7% | |
| 504 | 1 | 0.1% |
| Distinct | 27 |
|---|---|
| Distinct (%) | 7.9% |
| Missing | 659 |
| Missing (%) | 65.9% |
| Memory size | 7.8 KiB |
| STRONG-ARM (HANDS, FIST, FEET OR BODILY FORCE) | |
|---|---|
| UNKNOWN WEAPON/OTHER WEAPON | |
| VERBAL THREAT | |
| HAND GUN | 15 |
| KNIFE WITH BLADE 6INCHES OR LESS | 13 |
| Other values (22) |
| Value | Count | Frequency (%) | |
| STRONG-ARM (HANDS, FIST, FEET OR BODILY FORCE) | 201 | 20.1% | |
| UNKNOWN WEAPON/OTHER WEAPON | 36 | 3.6% | |
| VERBAL THREAT | 27 | 2.7% | |
| HAND GUN | 15 | 1.5% | |
| KNIFE WITH BLADE 6INCHES OR LESS | 13 | 1.3% | |
| SEMI-AUTOMATIC PISTOL | 7 | 0.7% | |
| OTHER KNIFE | 6 | 0.6% | |
| STICK | 4 | 0.4% | |
| BLUNT INSTRUMENT | 4 | 0.4% | |
| VEHICLE | 4 | 0.4% | |
| Other values (17) | 24 | 2.4% | |
| (Missing) | 659 | 65.9% |
Frequencies of value counts
Unique
| Unique | 12 ? |
|---|---|
| Unique (%) | 3.5% |
Histogram of lengths of the category
Length
| Max length | 46 |
|---|---|
| Median length | 3 |
| Mean length | 13.735 |
| Min length | 3 |
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.8 KiB |
| IC | |
|---|---|
| AA | |
| AO | |
| JA | 6 |
| JO | 1 |
| Value | Count | Frequency (%) | |
| IC | 779 | 77.9% | |
| AA | 109 | 10.9% | |
| AO | 105 | 10.5% | |
| JA | 6 | 0.6% | |
| JO | 1 | 0.1% |
Frequencies of value counts
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 0.1% |
Histogram of lengths of the category
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.8 KiB |
| Invest Cont | |
|---|---|
| Adult Arrest | |
| Adult Other | |
| Juv Arrest | 6 |
| Juv Other | 1 |
| Value | Count | Frequency (%) | |
| Invest Cont | 779 | 77.9% | |
| Adult Arrest | 109 | 10.9% | |
| Adult Other | 105 | 10.5% | |
| Juv Arrest | 6 | 0.6% | |
| Juv Other | 1 | 0.1% |
Frequencies of value counts
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 0.1% |
Histogram of lengths of the category
Length
| Max length | 12 |
|---|---|
| Median length | 11 |
| Mean length | 11.101 |
| Min length | 9 |
| Distinct | 69 |
|---|---|
| Distinct (%) | 6.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 508.279 |
|---|---|
| Minimum | 121 |
| Maximum | 956 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.8 KiB |
Quantile statistics
| Minimum | 121 |
|---|---|
| 5-th percentile | 230 |
| Q1 | 330 |
| median | 442 |
| Q3 | 626 |
| 95-th percentile | 928 |
| Maximum | 956 |
| Range | 835 |
| Interquartile range (IQR) | 296 |
Descriptive statistics
| Standard deviation | 207.0083564 |
|---|---|
| Coefficient of variation (CV) | 0.4072730851 |
| Kurtosis | -0.7411983295 |
| Mean | 508.279 |
| Median Absolute Deviation (MAD) | 132 |
| Skewness | 0.4899837297 |
| Sum | 508279 |
| Variance | 42852.45962 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 624 | 90 | 9.0% | |
| 440 | 87 | 8.7% | |
| 330 | 82 | 8.2% | |
| 510 | 81 | 8.1% | |
| 310 | 76 | 7.6% | |
| 626 | 62 | 6.2% | |
| 354 | 51 | 5.1% | |
| 740 | 47 | 4.7% | |
| 745 | 41 | 4.1% | |
| 230 | 39 | 3.9% | |
| Other values (59) | 344 | 34.4% |
| Value | Count | Frequency (%) | |
| 121 | 4 | 0.4% | |
| 122 | 1 | 0.1% | |
| 210 | 38 | 3.8% | |
| 220 | 3 | 0.3% | |
| 230 | 39 | 3.9% |
| Value | Count | Frequency (%) | |
| 956 | 7 | 0.7% | |
| 949 | 1 | 0.1% | |
| 946 | 10 | 1.0% | |
| 940 | 1 | 0.1% | |
| 933 | 1 | 0.1% |
| Distinct | 13 |
|---|---|
| Distinct (%) | 18.8% |
| Missing | 931 |
| Missing (%) | 93.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 944.3913043 |
|---|---|
| Minimum | 480 |
| Maximum | 998 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.8 KiB |
Quantile statistics
| Minimum | 480 |
|---|---|
| 5-th percentile | 624.8 |
| Q1 | 998 |
| median | 998 |
| Q3 | 998 |
| 95-th percentile | 998 |
| Maximum | 998 |
| Range | 518 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 128.6806601 |
|---|---|
| Coefficient of variation (CV) | 0.1362577773 |
| Kurtosis | 4.542303734 |
| Mean | 944.3913043 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -2.383914463 |
| Sum | 65163 |
| Variance | 16558.71228 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=13)
| Value | Count | Frequency (%) | |
| 998 | 56 | 5.6% | |
| 624 | 2 | 0.2% | |
| 946 | 1 | 0.1% | |
| 653 | 1 | 0.1% | |
| 860 | 1 | 0.1% | |
| 930 | 1 | 0.1% | |
| 510 | 1 | 0.1% | |
| 821 | 1 | 0.1% | |
| 626 | 1 | 0.1% | |
| 649 | 1 | 0.1% | |
| Other values (3) | 3 | 0.3% | |
| (Missing) | 931 | 93.1% |
| Value | Count | Frequency (%) | |
| 480 | 1 | 0.1% | |
| 510 | 1 | 0.1% | |
| 624 | 2 | 0.2% | |
| 626 | 1 | 0.1% | |
| 649 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 998 | 56 | 5.6% | |
| 946 | 1 | 0.1% | |
| 930 | 1 | 0.1% | |
| 860 | 1 | 0.1% | |
| 821 | 1 | 0.1% |
| Distinct | 2 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 998 |
| Missing (%) | 99.8% |
| Memory size | 7.8 KiB |
| 999 | |
|---|---|
| 998 |
| Value | Count | Frequency (%) | |
| 999 | 1 | 0.1% | |
| 998 | 1 | 0.1% | |
| (Missing) | 998 | 99.8% |
Frequencies of value counts
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | 100.0% |
Histogram of lengths of the category
Length
| Max length | 5 |
|---|---|
| Median length | 3 |
| Mean length | 3.004 |
| Min length | 3 |
| Distinct | 935 |
|---|---|
| Distinct (%) | 93.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.8 KiB |
| SHERMAN WY | 5 |
|---|---|
| 6TH ST | 3 |
| 1ST ST | 3 |
| 6700 11TH AV | 3 |
| 3RD | 3 |
| Other values (930) |
| Value | Count | Frequency (%) | |
| SHERMAN WY | 5 | 0.5% | |
| 6TH ST | 3 | 0.3% | |
| 1ST ST | 3 | 0.3% | |
| 6700 11TH AV | 3 | 0.3% | |
| 3RD | 3 | 0.3% | |
| 9300 TAMPA AV | 3 | 0.3% | |
| WASHINGTON | 3 | 0.3% | |
| NORMANDIE AV | 2 | 0.2% | |
| 13100 BROMONT AV | 2 | 0.2% | |
| 1600 WILSHIRE BL | 2 | 0.2% | |
| Other values (925) | 971 | 97.1% |
Frequencies of value counts
Unique
| Unique | 879 ? |
|---|---|
| Unique (%) | 87.9% |
Histogram of lengths of the category
Length
| Max length | 40 |
|---|---|
| Median length | 39 |
| Mean length | 35.46 |
| Min length | 3 |
| Distinct | 154 |
|---|---|
| Distinct (%) | 84.2% |
| Missing | 817 |
| Missing (%) | 81.7% |
| Memory size | 7.8 KiB |
| CENTRAL AV | 5 |
|---|---|
| BROADWAY | 5 |
| VERMONT AV | 4 |
| MAIN | 4 |
| AVALON | 3 |
| Other values (149) |
| Value | Count | Frequency (%) | |
| CENTRAL AV | 5 | 0.5% | |
| BROADWAY | 5 | 0.5% | |
| VERMONT AV | 4 | 0.4% | |
| MAIN | 4 | 0.4% | |
| AVALON | 3 | 0.3% | |
| LASSEN | 2 | 0.2% | |
| OLYMPIC BL | 2 | 0.2% | |
| SAN PEDRO ST | 2 | 0.2% | |
| HOLLYWOOD BL | 2 | 0.2% | |
| SOTO | 2 | 0.2% | |
| Other values (144) | 152 | 15.2% | |
| (Missing) | 817 | 81.7% |
Frequencies of value counts
Unique
| Unique | 136 ? |
|---|---|
| Unique (%) | 74.3% |
Histogram of lengths of the category
Length
| Max length | 34 |
|---|---|
| Median length | 3 |
| Mean length | 6.138 |
| Min length | 3 |
| Distinct | 954 |
|---|---|
| Distinct (%) | 95.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.8 KiB |
| {'latitude': '33.9782', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.3294'} | 3 |
|---|---|
| {'latitude': '34.0215', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.2868'} | 3 |
| {'latitude': '34.2428', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.5361'} | 3 |
| {'latitude': '34.0554', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.2702'} | 2 |
| {'latitude': '34.0327', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.3002'} | 2 |
| Other values (949) |
| Value | Count | Frequency (%) | |
| {'latitude': '33.9782', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.3294'} | 3 | 0.3% | |
| {'latitude': '34.0215', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.2868'} | 3 | 0.3% | |
| {'latitude': '34.2428', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.5361'} | 3 | 0.3% | |
| {'latitude': '34.0554', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.2702'} | 2 | 0.2% | |
| {'latitude': '34.0327', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.3002'} | 2 | 0.2% | |
| {'latitude': '34.2299', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.5536'} | 2 | 0.2% | |
| {'latitude': '34.2336', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.4517'} | 2 | 0.2% | |
| {'latitude': '33.9667', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.2893'} | 2 | 0.2% | |
| {'latitude': '34.0618', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.2979'} | 2 | 0.2% | |
| {'latitude': '34.0636', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.3047'} | 2 | 0.2% | |
| Other values (944) | 977 | 97.7% |
Frequencies of value counts
Unique
| Unique | 911 ? |
|---|---|
| Unique (%) | 91.1% |
Histogram of lengths of the category
Length
| Max length | 139 |
|---|---|
| Median length | 139 |
| Mean length | 138.737 |
| Min length | 129 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| df_index | DR Number | Date Reported | Date Occurred | Time Occurred | Area ID | Area Name | Reporting District | Crime Code | Crime Code Description | MO Codes | Victim Age | Victim Sex | Victim Descent | Premise Code | Premise Description | Weapon Used Code | Weapon Description | Status Code | Status Description | Crime Code 1 | Crime Code 2 | Crime Code 3 | Crime Code 4 | Address | Cross Street | Location | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 982934 | 142106122 | 2014-02-17T00:00:00 | 2014-02-17T00:00:00 | 1745 | 21 | Topanga | 2147 | 930 | CRIMINAL THREATS - NO WEAPON DISPLAYED | 0421 | 44 | F | H | 501.0 | SINGLE FAMILY DWELLING | 511.0 | VERBAL THREAT | IC | Invest Cont | 930.0 | NaN | NaN | NaN | 20900 HART ST | NaN | {'latitude': '34.1974', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.5884'} |
| 1 | 1414445 | 162013590 | 2016-07-14T00:00:00 | 2016-07-13T00:00:00 | 1900 | 20 | Olympic | 2002 | 442 | SHOPLIFTING - PETTY THEFT ($950 & UNDER) | 0344 | 0 | X | X | 401.0 | MINI-MART | NaN | NaN | IC | Invest Cont | 442.0 | NaN | NaN | NaN | 400 N WESTERN AV | NaN | {'latitude': '34.0799', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.3113'} |
| 2 | 1802931 | 181318857 | 2018-09-08T00:00:00 | 2018-08-08T00:00:00 | 1700 | 13 | Newton | 1363 | 440 | THEFT PLAIN - PETTY ($950 & UNDER) | 2000 1814 0444 0416 0446 0417 0329 | 38 | F | W | 505.0 | MOTEL | 400.0 | STRONG-ARM (HANDS, FIST, FEET OR BODILY FORCE) | IC | Invest Cont | 440.0 | 626.0 | NaN | NaN | 5000 S CENTRAL AV | NaN | {'latitude': '33.9983', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.2608'} |
| 3 | 300859 | 111117198 | 2011-09-04T00:00:00 | 2011-09-04T00:00:00 | 1210 | 11 | Northeast | 1162 | 433 | DRIVING WITHOUT OWNER CONSENT (DWOC) | 1501 | 29 | M | B | 108.0 | PARKING LOT | NaN | NaN | IC | Invest Cont | 433.0 | NaN | NaN | NaN | 1300 N VERMONT AV | NaN | {'latitude': '34.0956', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.2918'} |
| 4 | 259275 | 110625988 | 2011-10-30T00:00:00 | 2011-10-30T00:00:00 | 25 | 6 | Hollywood | 657 | 626 | INTIMATE PARTNER - SIMPLE ASSAULT | 0400 2000 | 20 | F | B | 502.0 | MULTI-UNIT DWELLING (APARTMENT, DUPLEX, ETC) | 400.0 | STRONG-ARM (HANDS, FIST, FEET OR BODILY FORCE) | AO | Adult Other | 626.0 | NaN | NaN | NaN | 5600 SANTA MONICA BL | NaN | {'latitude': '34.0908', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.3113'} |
| 5 | 309074 | 111214172 | 2011-05-24T00:00:00 | 2011-05-23T00:00:00 | 2200 | 12 | 77th Street | 1269 | 510 | VEHICLE - STOLEN | NaN | 0 | NaN | NaN | 101.0 | STREET | NaN | NaN | IC | Invest Cont | 510.0 | NaN | NaN | NaN | 80TH ST | CENTRAL AV | {'latitude': '33.9665', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.2564'} |
| 6 | 1439833 | 170109651 | 2017-03-25T00:00:00 | 2017-03-24T00:00:00 | 1930 | 1 | Central | 185 | 330 | BURGLARY FROM VEHICLE | 0344 1609 | 28 | M | W | 101.0 | STREET | NaN | NaN | IC | Invest Cont | 330.0 | NaN | NaN | NaN | 11TH ST | LOS ANGELES ST | {'latitude': '34.0381', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.2566'} |
| 7 | 232570 | 110320525 | 2011-09-13T00:00:00 | 2011-09-12T00:00:00 | 1545 | 3 | Southwest | 358 | 440 | THEFT PLAIN - PETTY ($950 & UNDER) | 0344 1607 | 20 | M | H | 722.0 | COLLEGE/JUNIOR COLLEGE/UNIVERSITY | NaN | NaN | IC | Invest Cont | 440.0 | NaN | NaN | NaN | 3600 TROUSDALE PY | NaN | {'latitude': '34.0215', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.2868'} |
| 8 | 577329 | 121906564 | 2012-02-13T00:00:00 | 2012-02-12T00:00:00 | 1930 | 19 | Mission | 1964 | 956 | LETTERS, LEWD - TELEPHONE CALLS, LEWD | 1501 | 37 | F | H | 502.0 | MULTI-UNIT DWELLING (APARTMENT, DUPLEX, ETC) | NaN | NaN | IC | Invest Cont | 956.0 | NaN | NaN | NaN | 9400 VAN NUYS BL | NaN | {'latitude': '34.2412', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.4502'} |
| 9 | 52069 | 101613620 | 2010-07-05T00:00:00 | 2010-01-01T00:00:00 | 1200 | 16 | Foothill | 1672 | 930 | CRIMINAL THREATS - NO WEAPON DISPLAYED | 0443 0913 | 6 | M | H | 501.0 | SINGLE FAMILY DWELLING | NaN | NaN | IC | Invest Cont | 930.0 | NaN | NaN | NaN | 11900 PEORIA ST | NaN | {'latitude': '34.2297', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.3924'} |
Last rows
| df_index | DR Number | Date Reported | Date Occurred | Time Occurred | Area ID | Area Name | Reporting District | Crime Code | Crime Code Description | MO Codes | Victim Age | Victim Sex | Victim Descent | Premise Code | Premise Description | Weapon Used Code | Weapon Description | Status Code | Status Description | Crime Code 1 | Crime Code 2 | Crime Code 3 | Crime Code 4 | Address | Cross Street | Location | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 990 | 1024309 | 150317484 | 2015-08-01T00:00:00 | 2015-07-31T00:00:00 | 1130 | 3 | Southwest | 314 | 310 | BURGLARY | 1601 1602 0344 | 24 | M | W | 502.0 | MULTI-UNIT DWELLING (APARTMENT, DUPLEX, ETC) | NaN | NaN | IC | Invest Cont | 310.0 | NaN | NaN | NaN | 3800 W 27TH ST | NaN | {'latitude': '34.0312', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.3262'} |
| 991 | 1918511 | 190511623 | 6212019-01-01T00:00:00 | 2019-06-21T00:00:00 | 1550 | 5 | Harbor | 517 | 901 | VIOLATION OF RESTRAINING ORDER | 1300 1309 2038 | 36 | F | H | 501.0 | SINGLE FAMILY DWELLING | NaN | NaN | IC | Invest Cont | 901.0 | NaN | NaN | NaN | 1100 BROAD AV | NaN | {'latitude': '33.7849', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.2612'} |
| 992 | 1719910 | 180518986 | 2018-11-25T00:00:00 | 2018-11-23T00:00:00 | 1800 | 5 | Harbor | 507 | 330 | BURGLARY FROM VEHICLE | 0344 1300 0329 1609 | 40 | F | A | 101.0 | STREET | NaN | NaN | IC | Invest Cont | 330.0 | NaN | NaN | NaN | 1300 HARMONY WY | NaN | {'latitude': '33.8209', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.2995'} |
| 993 | 496335 | 121020501 | 2012-12-21T00:00:00 | 2012-12-20T00:00:00 | 1000 | 10 | West Valley | 1047 | 901 | VIOLATION OF RESTRAINING ORDER | NaN | 35 | F | O | 501.0 | SINGLE FAMILY DWELLING | NaN | NaN | AO | Adult Other | 901.0 | NaN | NaN | NaN | 5800 TEXHOMA AV | NaN | {'latitude': '34.1766', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.5159'} |
| 994 | 1487715 | 170516028 | 2017-09-14T00:00:00 | 2017-09-14T00:00:00 | 2040 | 5 | Harbor | 566 | 901 | VIOLATION OF RESTRAINING ORDER | 1813 | 36 | F | H | 502.0 | MULTI-UNIT DWELLING (APARTMENT, DUPLEX, ETC) | NaN | NaN | AA | Adult Arrest | 901.0 | NaN | NaN | NaN | 300 W 11TH ST | NaN | {'latitude': '33.7342', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.2836'} |
| 995 | 844581 | 140516189 | 2014-10-16T00:00:00 | 2014-10-14T00:00:00 | 2000 | 5 | Harbor | 567 | 310 | BURGLARY | 0344 1602 0358 | 40 | F | H | 707.0 | GARAGE/CARPORT | NaN | NaN | IC | Invest Cont | 310.0 | NaN | NaN | NaN | 1700 S PACIFIC AV | NaN | {'latitude': '33.7288', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.288'} |
| 996 | 324209 | 111321388 | 2011-09-20T00:00:00 | 2011-09-20T00:00:00 | 1935 | 13 | Newton | 1375 | 440 | THEFT PLAIN - PETTY ($950 & UNDER) | 0100 0202 0344 | 19 | F | H | 102.0 | SIDEWALK | NaN | NaN | IC | Invest Cont | 440.0 | NaN | NaN | NaN | 58TH ST | CENTRAL AV | {'latitude': '33.9902', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.2564'} |
| 997 | 175149 | 101100587 | 2010-01-25T00:00:00 | 2010-01-25T00:00:00 | 40 | 11 | Northeast | 1125 | 626 | INTIMATE PARTNER - SIMPLE ASSAULT | 0416 2000 | 34 | F | W | 501.0 | SINGLE FAMILY DWELLING | 400.0 | STRONG-ARM (HANDS, FIST, FEET OR BODILY FORCE) | AA | Adult Arrest | 626.0 | NaN | NaN | NaN | 4700 TOLAND WY | NaN | {'latitude': '34.12', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.2139'} |
| 998 | 504270 | 121120035 | 2012-10-27T00:00:00 | 2012-10-26T00:00:00 | 1800 | 11 | Northeast | 1162 | 442 | SHOPLIFTING - PETTY THEFT ($950 & UNDER) | 0325 | 24 | M | B | 402.0 | MARKET | NaN | NaN | AO | Adult Other | 442.0 | NaN | NaN | NaN | 4500 W SUNSET BL | NaN | {'latitude': '34.0982', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.2874'} |
| 999 | 1891737 | 191304433 | 2019-01-07T00:00:00 | 2018-11-15T00:00:00 | 1200 | 13 | Newton | 1371 | 649 | DOCUMENT FORGERY / STOLEN FELONY | 0923 | 36 | M | H | 501.0 | SINGLE FAMILY DWELLING | NaN | NaN | IC | Invest Cont | 649.0 | NaN | NaN | NaN | 100 W 56TH ST | NaN | {'latitude': '33.9915', 'needs_recoding': False, 'human_address': '{"address":"","city":"","state":"","zip":""}', 'longitude': '-118.2739'} |